Harold Frederick Shipman, Jr. (14 January 1946 – 13 January 2004), known to acquaintances as Fred Shipman, was an English general practitioner and serial killer. He is considered to be one of the most prolific serial killers in modern history, with an estimated 250 victims. On 31 January 2000, Shipman was found guilty of murdering fifteen patients under his care. He was sentenced to life imprisonment with a whole life order. Shipman died by suicide by hanging himself in his cell at HM Prison Wakefield, West Yorkshire, on 13 January 2004, aged 57. More details here: https://en.wikipedia.org/wiki/Harold_Shipman
.........Loading Everything for our analysis.
import pyodbc
import pandas as pd
import numpy as np
from matplotlib import pyplot as plt
from IPython.display import display
import plotly.graph_objects as go
import numpy as np
import sqlalchemy as sa
import warnings
warnings.filterwarnings('ignore')
pd.options.display.max_rows = None
pd.options.display.max_columns = None
try:
server = 'DESKTOP-7AVUQ5G'
database = 'practical_sql'
trusted_connection = 'yes'
driver = 'SQL Server'
pd.set_option('display.max_columns', None)
conn = pyodbc.connect(f'Driver={driver};'
f'Server={server};'
f'Database={database};'
f'Trusted_Connection={trusted_connection};')
cursor = conn.cursor()
print("Everything is working as expected")
except:
print("Oops, something went wrong!")
Everything is working as expected
pd.options.display.max_rows = None
pd.options.display.max_columns = None
query = """
SELECT *
FROM [practical_sql].[dbo].[shipman_confirmed_victims]
"""
df = pd.read_sql_query(query, conn)
df
| DateofDeath | Name | Age | PlaceofDeath | Decision | yearOfDeath | gender | fractionalDeathYear | ageBracket | gender2 | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1975-03-17 | Eva Lyons | 70 | Own home | Unlawful killing | 1975 | False | 1974.709961 | 70-74 | Women |
| 1 | 1978-08-07 | Sarah Hannah Marsland | 86 | Own home | Unlawful killing | 1978 | False | 1978.099976 | 85-89 | Women |
| 2 | 1978-08-30 | Mary Ellen Jordan | 73 | Own home | Unlawful killing | 1978 | False | 1978.160034 | 70-74 | Women |
| 3 | 1978-12-07 | Harold Bramwell | 73 | Own home | Unlawful killing | 1978 | True | 1978.439941 | 70-74 | Men |
| 4 | 1978-12-20 | Annie Campbell | 88 | Own home | Unlawful killing | 1978 | False | 1978.469971 | 85-89 | Women |
| 5 | 1979-08-10 | Alice Maude Gorton | 76 | Own home | Unlawful killing | 1979 | False | 1979.109985 | 75-79 | Women |
| 6 | 1979-11-28 | Jack Leslie Shelmerdine | 77 | Hospital | Unlawful killing | 1979 | True | 1979.410034 | 75-79 | Men |
| 7 | 1981-04-18 | May Slater | 84 | Own home | Unlawful killing | 1981 | False | 1980.800049 | 80-84 | Women |
| 8 | 1981-08-26 | Elizabeth Ashworth | 81 | Own home | Unlawful killing | 1981 | False | 1981.150024 | 80-84 | Women |
| 9 | 1983-01-04 | Percy Ward | 90 | Own home | Unlawful killing | 1983 | True | 1982.510010 | 90-94 | Men |
| 10 | 1983-06-28 | Moira Ashton Fox | 77 | Own home | Unlawful killing | 1983 | False | 1982.989990 | 75-79 | Women |
| 11 | 1984-01-07 | Dorothy Tucker | 51 | Own home | Unlawful killing | 1984 | False | 1983.520020 | 50-54 | Women |
| 12 | 1984-02-08 | Gladys Roberts | 78 | Own home | Unlawful killing | 1984 | False | 1983.609985 | 75-79 | Women |
| 13 | 1984-04-15 | Joseph Bardsley | 83 | Own home | Unlawful killing | 1984 | True | 1983.790039 | 80-84 | Men |
| 14 | 1984-04-24 | Winifred Arrowsmith | 70 | Own home | Unlawful killing | 1984 | False | 1983.810059 | 70-74 | Women |
| 15 | 1984-09-21 | Mary Winterbottom | 76 | Own home | Unlawful killing | 1984 | False | 1984.219971 | 75-79 | Women |
| 16 | 1984-11-27 | Ada Ashworth | 87 | Own home | Unlawful killing | 1984 | False | 1984.410034 | 85-89 | Women |
| 17 | 1984-12-17 | Joseph Vincent Everall | 80 | Own home | Unlawful killing | 1984 | True | 1984.459961 | 80-84 | Men |
| 18 | 1984-12-18 | Edith Wibberley | 76 | Own home | Unlawful killing | 1984 | False | 1984.469971 | 75-79 | Women |
| 19 | 1984-12-24 | Eileen Theresa Cox | 72 | Own home | Unlawful killing | 1984 | False | 1984.479980 | 70-74 | Women |
| 20 | 1985-01-02 | Peter Lewis | 41 | Own home | Unlawful killing | 1985 | True | 1984.510010 | 40-44 | Men |
| 21 | 1985-02-01 | May Brookes | 74 | Own home | Unlawful killing | 1985 | False | 1984.589966 | 70-74 | Women |
| 22 | 1985-02-04 | Ellen Higson | 84 | Own home | Unlawful killing | 1985 | False | 1984.599976 | 80-84 | Women |
| 23 | 1985-02-15 | Margaret Ann Conway | 69 | Own home | Unlawful killing | 1985 | False | 1984.630005 | 65-69 | Women |
| 24 | 1985-02-22 | Kathleen McDonald | 73 | Own home | Unlawful killing | 1985 | False | 1984.650024 | 70-74 | Women |
| 25 | 1985-06-26 | Thomas Moult | 70 | Own home | Unlawful killing | 1985 | True | 1984.989990 | 70-74 | Men |
| 26 | 1985-06-26 | Mildred Robinson | 84 | Own home | Unlawful killing | 1985 | False | 1984.989990 | 80-84 | Women |
| 27 | 1985-08-23 | Frances Elizabeth Turner | 85 | Own home | Unlawful killing | 1985 | False | 1985.150024 | 85-89 | Women |
| 28 | 1985-12-17 | Selina Mackenzie | 77 | Own home | Unlawful killing | 1985 | False | 1985.459961 | 75-79 | Women |
| 29 | 1985-12-20 | Vera Bramwell | 79 | Own home | Unlawful killing | 1985 | False | 1985.469971 | 75-79 | Women |
| 30 | 1985-12-31 | Fred Kellett | 79 | Own home | Unlawful killing | 1985 | True | 1985.500000 | 75-79 | Men |
| 31 | 1986-01-07 | Deborah Middleton | 81 | Own home | Unlawful killing | 1986 | False | 1985.520020 | 80-84 | Women |
| 32 | 1986-04-23 | Dorothy Fletcher | 74 | Residential Home | Unlawful killing | 1986 | False | 1985.810059 | 70-74 | Women |
| 33 | 1986-06-06 | Thomas Fowden | 81 | Own home | Unlawful killing | 1986 | True | 1985.930054 | 80-84 | Men |
| 34 | 1986-09-15 | Mona Ashton White | 63 | Own home | Unlawful killing | 1986 | False | 1986.209961 | 60-64 | Women |
| 35 | 1986-10-07 | Mary Tomlin | 73 | Own home | Unlawful killing | 1986 | False | 1986.270020 | 70-74 | Women |
| 36 | 1986-11-17 | Beatrice Toft | 59 | Own home | Unlawful killing | 1986 | False | 1986.380005 | 55-59 | Women |
| 37 | 1986-12-16 | Lily Broadbent | 75 | Own home | Unlawful killing | 1986 | False | 1986.459961 | 75-79 | Women |
| 38 | 1986-12-23 | James Wood | 82 | Own home | Unlawful killing | 1986 | True | 1986.479980 | 80-84 | Men |
| 39 | 1987-03-30 | Frank Halliday | 76 | Own home | Unlawful killing | 1987 | True | 1986.750000 | 75-79 | Men |
| 40 | 1987-04-01 | Albert Cheetham | 85 | Own home | Unlawful killing | 1987 | True | 1986.750000 | 85-89 | Men |
| 41 | 1987-04-16 | Alice Thomas | 83 | Own home | Unlawful killing | 1987 | False | 1986.790039 | 80-84 | Women |
| 42 | 1987-05-08 | Jane Frances Rostron | 78 | Own home | Unlawful killing | 1987 | False | 1986.849976 | 75-79 | Women |
| 43 | 1987-09-14 | Nancy Anne Brassington | 71 | Own home | Unlawful killing | 1987 | False | 1987.209961 | 70-74 | Women |
| 44 | 1987-12-11 | Margaret Townsend | 80 | Own home | Unlawful killing | 1987 | False | 1987.449951 | 80-84 | Women |
| 45 | 1987-12-29 | Nellie Bardsley | 69 | Own home | Unlawful killing | 1987 | False | 1987.500000 | 65-69 | Women |
| 46 | 1987-12-30 | Elizabeth Ann Rogers | 74 | Own home | Unlawful killing | 1987 | False | 1987.500000 | 70-74 | Women |
| 47 | 1988-01-05 | Elizabeth Fletcher | 90 | Own home | Unlawful killing | 1988 | False | 1987.510010 | 90-94 | Women |
| 48 | 1988-01-15 | Alice Mary Jones | 83 | Own home | Unlawful killing | 1988 | False | 1987.540039 | 80-84 | Women |
| 49 | 1988-02-09 | Dorothea Hill Renwick | 90 | Own home | Unlawful killing | 1988 | False | 1987.609985 | 90-94 | Women |
| 50 | 1988-02-15 | Ann Cooper | 93 | Own home | Unlawful killing | 1988 | False | 1987.619995 | 90-94 | Women |
| 51 | 1988-02-15 | Jane Jones | 83 | Own home | Unlawful killing | 1988 | False | 1987.619995 | 80-84 | Women |
| 52 | 1988-02-16 | Lavinia Robinson | 84 | Own home | Unlawful killing | 1988 | False | 1987.630005 | 80-84 | Women |
| 53 | 1988-09-18 | Rose Ann Adshead | 80 | Own home | Unlawful killing | 1988 | False | 1988.219971 | 80-84 | Women |
| 54 | 1988-10-20 | Alice Prestwich | 69 | Own home | Unlawful killing | 1988 | False | 1988.300049 | 65-69 | Women |
| 55 | 1988-11-06 | Walter Tingle | 85 | Own home | Unlawful killing | 1988 | True | 1988.349976 | 85-89 | Men |
| 56 | 1988-12-17 | Harry Stafford | 87 | Own home | Unlawful killing | 1988 | True | 1988.459961 | 85-89 | Men |
| 57 | 1988-12-19 | Ethel Bennett | 80 | Own home | Unlawful killing | 1988 | False | 1988.469971 | 80-84 | Women |
| 58 | 1989-01-31 | Wilfred Chappell | 80 | Own home | Unlawful killing | 1989 | False | 1988.589966 | 80-84 | Women |
| 59 | 1989-03-08 | Mary Emma Hamer | 81 | Shipman's surgery | Unlawful killing | 1989 | False | 1988.680054 | 80-84 | Women |
| 60 | 1989-05-12 | Beatrice Helen Clee | 78 | Own home | Unlawful killing | 1989 | False | 1988.859985 | 75-79 | Women |
| 61 | 1989-06-05 | Josephine Hall | 69 | Own home | Unlawful killing | 1989 | False | 1988.930054 | 65-69 | Women |
| 62 | 1989-07-06 | Hilda Fitton | 75 | Own home | Unlawful killing | 1989 | False | 1989.010010 | 75-79 | Women |
| 63 | 1989-08-14 | Marion Carradice | 80 | Own home | Unlawful killing | 1989 | False | 1989.119995 | 80-84 | Women |
| 64 | 1989-09-22 | Elsie Harrop | 82 | Own home | Unlawful killing | 1989 | False | 1989.229980 | 80-84 | Women |
| 65 | 1989-09-26 | Elizabeth Mary Burke | 82 | Own home | Unlawful killing | 1989 | False | 1989.239990 | 80-84 | Women |
| 66 | 1989-10-15 | Sarah Jane Williamson | 82 | Own home | Unlawful killing | 1989 | False | 1989.290039 | 80-84 | Women |
| 67 | 1989-10-16 | John Charlton | 81 | Own home | Unlawful killing | 1989 | True | 1989.290039 | 80-84 | Men |
| 68 | 1989-10-18 | George Edgar Vizor | 67 | Own home | Unlawful killing | 1989 | True | 1989.300049 | 65-69 | Men |
| 69 | 1989-11-06 | Joseph Frank Wilcockson | 85 | Own home | Unlawful killing | 1989 | True | 1989.349976 | 85-89 | Men |
| 70 | 1990-09-18 | Dorothy Rowarth | 56 | Own home | Unlawful killing | 1990 | False | 1990.219971 | 55-59 | Women |
| 71 | 1990-12-30 | Mary Rose Dudley | 69 | Own home | Unlawful killing | 1990 | False | 1990.500000 | 65-69 | Women |
| 72 | 1992-10-07 | Monica Rene Sparkes | 72 | Own home | Unlawful killing | 1992 | False | 1992.270020 | 70-74 | Women |
| 73 | 1993-02-24 | Olive Heginbotham | 86 | Own home | Unlawful killing | 1993 | False | 1992.650024 | 85-89 | Women |
| 74 | 1993-02-24 | Hilda Mary Couzens | 92 | Own home | Unlawful killing | 1993 | False | 1992.650024 | 90-94 | Women |
| 75 | 1993-03-22 | Amy Whitehead | 82 | Own home | Unlawful killing | 1993 | False | 1992.719971 | 80-84 | Women |
| 76 | 1993-04-08 | Mary Emma Andrew | 86 | Own home | Unlawful killing | 1993 | False | 1992.770020 | 85-89 | Women |
| 77 | 1993-04-17 | Sarah Ashworth | 74 | Own home | Unlawful killing | 1993 | False | 1992.790039 | 70-74 | Women |
| 78 | 1993-04-26 | Fanny Nichols | 84 | Own home | Unlawful killing | 1993 | False | 1992.819946 | 80-84 | Women |
| 79 | 1993-04-27 | Marjorie Parker | 74 | Own home | Unlawful killing | 1993 | False | 1992.819946 | 70-74 | Women |
| 80 | 1993-05-02 | Nellie Mullen | 77 | Own home | Unlawful killing | 1993 | False | 1992.839966 | 75-79 | Women |
| 81 | 1993-05-04 | Edna May Llewellyn | 68 | Own home | Unlawful killing | 1993 | False | 1992.839966 | 65-69 | Women |
| 82 | 1993-05-12 | Emily Morgan | 84 | Own home | Unlawful killing | 1993 | False | 1992.859985 | 80-84 | Women |
| 83 | 1993-05-13 | Violet May Bird | 60 | Own home | Unlawful killing | 1993 | False | 1992.869995 | 60-64 | Women |
| 84 | 1993-07-22 | Jose Kathleen Diana Richards | 74 | Own home | Unlawful killing | 1993 | False | 1993.060059 | 70-74 | Women |
| 85 | 1993-08-16 | Edith Calverley | 77 | Own home | Unlawful killing | 1993 | False | 1993.130005 | 75-79 | Women |
| 86 | 1993-12-16 | Joseph Leigh | 78 | Own home | Unlawful killing | 1993 | False | 1993.459961 | 75-79 | Women |
| 87 | 1993-12-22 | Eileen Robinson | 54 | Own home | Unlawful killing | 1993 | False | 1993.479980 | 50-54 | Women |
| 88 | 1993-12-31 | Charles Edward Brocklehurst | 90 | Own home | Unlawful killing | 1993 | True | 1993.500000 | 90-94 | Men |
| 89 | 1994-01-04 | Joan Milray Harding | 82 | Shipman's surgery | Unlawful killing | 1994 | False | 1993.510010 | 80-84 | Women |
| 90 | 1994-01-13 | Christine Hancock | 53 | Own home | Unlawful killing | 1994 | False | 1993.540039 | 50-54 | Women |
| 91 | 1994-02-09 | Elsie Platt | 73 | Own home | Unlawful killing | 1994 | False | 1993.609985 | 70-74 | Women |
| 92 | 1994-05-17 | Mary Alice Smith | 84 | Own home | Unlawful killing | 1994 | False | 1993.880005 | 80-84 | Women |
| 93 | 1994-05-25 | Ronnie Devenport | 57 | Own home | Unlawful killing | 1994 | False | 1993.900024 | 55-59 | Women |
| 94 | 1994-06-15 | Cicely Sharples | 87 | Own home | Unlawful killing | 1994 | False | 1993.959961 | 85-89 | Women |
| 95 | 1994-06-17 | Alice Christine Kitchen | 70 | Own home | Unlawful killing | 1994 | False | 1993.959961 | 70-74 | Women |
| 96 | 1994-07-27 | Maria Thornton | 78 | Own home | Unlawful killing | 1994 | False | 1994.069946 | 75-79 | Women |
| 97 | 1994-11-25 | Henrietta Walker | 87 | Own home | Unlawful killing | 1994 | False | 1994.400024 | 85-89 | Women |
| 98 | 1994-11-30 | Elizabeth Ellen Mellor | 75 | Own home | Unlawful killing | 1994 | False | 1994.420044 | 75-79 | Women |
| 99 | 1994-12-29 | John Bennett Molesdale | 81 | Own home | Unlawful killing | 1994 | False | 1994.500000 | 80-84 | Women |
| 100 | 1995-01-09 | Alice Kennedy | 88 | Own home | Unlawful killing | 1995 | False | 1994.530029 | 85-89 | Women |
| 101 | 1995-03-01 | Lucy Virgin | 70 | Own home | Unlawful killing | 1995 | False | 1994.670044 | 70-74 | Women |
| 102 | 1995-03-03 | Joseph Shaw | 88 | Own home | Unlawful killing | 1995 | True | 1994.670044 | 85-89 | Men |
| 103 | 1995-03-06 | Maria West | 81 | Own home | Conviction | 1995 | False | 1994.680054 | 80-84 | Women |
| 104 | 1995-03-07 | Netta Ashcroft | 71 | Own home | Unlawful killing | 1995 | False | 1994.680054 | 70-74 | Women |
| 105 | 1995-03-07 | Lily Bardsley | 88 | Own home | Unlawful killing | 1995 | False | 1994.680054 | 85-89 | Women |
| 106 | 1995-03-13 | Marie Antoinette Fernley | 53 | Own home | Unlawful killing | 1995 | False | 1994.699951 | 50-54 | Women |
| 107 | 1995-03-21 | John Crompton | 82 | Own home | Unlawful killing | 1995 | True | 1994.719971 | 80-84 | Men |
| 108 | 1995-03-26 | Frank Crompton | 86 | Own home | Unlawful killing | 1995 | True | 1994.729980 | 85-89 | Men |
| 109 | 1995-03-31 | Vera Brocklehurst | 70 | Own home | Unlawful killing | 1995 | False | 1994.750000 | 70-74 | Women |
| 110 | 1995-04-10 | Angela Philomena Tierney | 71 | Own home | Unlawful killing | 1995 | False | 1994.780029 | 70-74 | Women |
| 111 | 1995-04-13 | Edith Scott | 85 | Own home | Unlawful killing | 1995 | False | 1994.780029 | 85-89 | Women |
| 112 | 1995-04-14 | Clara Hackney | 84 | Own home | Unlawful killing | 1995 | False | 1994.790039 | 80-84 | Women |
| 113 | 1995-04-21 | Renate Eldtraude Overton | 47 | Hospital | Unlawful killing | 1995 | False | 1994.810059 | 45-49 | Women |
| 114 | 1995-05-04 | Kate Maud Sellors | 75 | Own home | Unlawful killing | 1995 | False | 1994.839966 | 75-79 | Women |
| 115 | 1995-06-02 | Clifford Barnes Heapey | 85 | Nursing home | Unlawful killing | 1995 | True | 1994.920044 | 85-89 | Men |
| 116 | 1995-06-13 | Bertha Moss | 68 | Shipman's surgery | Unlawful killing | 1995 | False | 1994.949951 | 65-69 | Women |
| 117 | 1995-06-17 | Brenda Ashworth | 63 | Own home | Unlawful killing | 1995 | False | 1994.959961 | 60-64 | Women |
| 118 | 1995-06-29 | Ernest Rudol | 82 | Own home | Unlawful killing | 1995 | False | 1994.989990 | 80-84 | Women |
| 119 | 1995-07-12 | Ada Matley Hilton | 88 | Own home | Unlawful killing | 1995 | False | 1995.030029 | 85-89 | Women |
| 120 | 1995-07-31 | Irene Aitken | 65 | Own home | Unlawful killing | 1995 | False | 1995.079956 | 65-69 | Women |
| 121 | 1995-08-29 | Arthur Henderson Stopford | 82 | Own home | Unlawful killing | 1995 | True | 1995.160034 | 80-84 | Men |
| 122 | 1995-09-14 | Geoffrey Bogle | 72 | Own home | Unlawful killing | 1995 | True | 1995.209961 | 70-74 | Men |
| 123 | 1995-09-26 | Dora Elizabeth Ashton | 87 | Shipman's surgery | Unlawful killing | 1995 | False | 1995.239990 | 85-89 | Women |
| 124 | 1995-10-24 | Muriel Margaret Ward | 87 | Own home | Unlawful killing | 1995 | False | 1995.319946 | 85-89 | Women |
| 125 | 1995-11-08 | Edith Brock | 74 | Own home | Unlawful killing | 1995 | False | 1995.359985 | 70-74 | Women |
| 126 | 1995-11-22 | Charles Henry Barlow | 88 | Own home | Unlawful killing | 1995 | True | 1995.390015 | 85-89 | Men |
| 127 | 1995-11-25 | Konrad Peter Ovcar-Robinson | 43 | Own home | Unlawful killing | 1995 | True | 1995.400024 | 40-44 | Men |
| 128 | 1995-12-14 | Elizabeth Teresa Sigley | 67 | Own home | Unlawful killing | 1995 | False | 1995.449951 | 65-69 | Women |
| 129 | 1995-12-14 | Kenneth Wharmby Woodhead | 75 | Own home | Unlawful killing | 1995 | True | 1995.449951 | 75-79 | Men |
| 130 | 1996-01-02 | Hilda Mary Hibbert | 81 | Own home | Unlawful killing | 1996 | False | 1995.500000 | 80-84 | Women |
| 131 | 1996-01-11 | Erla Copeland | 79 | Own home | Unlawful killing | 1996 | False | 1995.530029 | 75-79 | Women |
| 132 | 1996-02-21 | Jane Elizabeth Shelmerdine | 80 | Own home | Unlawful killing | 1996 | False | 1995.640015 | 80-84 | Women |
| 133 | 1996-02-27 | John Sheard Greenhalgh | 88 | Own home | Unlawful killing | 1996 | True | 1995.660034 | 85-89 | Men |
| 134 | 1996-03-12 | Minnie Doris Irene Galpin | 71 | Own home | Unlawful killing | 1996 | False | 1995.699951 | 70-74 | Women |
| 135 | 1996-04-18 | Marjorie Hope Waller | 79 | Own home | Unlawful killing | 1996 | False | 1995.800049 | 75-79 | Women |
| 136 | 1996-04-24 | John Stone | 77 | Own home | Unlawful killing | 1996 | True | 1995.810059 | 75-79 | Men |
| 137 | 1996-05-07 | Elsie Godfrey | 85 | Own home | Unlawful killing | 1996 | False | 1995.849976 | 85-89 | Women |
| 138 | 1996-05-13 | Edith Brady | 72 | Shipman's surgery | Unlawful killing | 1996 | False | 1995.869995 | 70-74 | Women |
| 139 | 1996-05-29 | Valerie Cuthbert | 54 | Own home | Unlawful killing | 1996 | False | 1995.910034 | 50-54 | Women |
| 140 | 1996-05-30 | Lilian Cullen | 77 | Own home | Unlawful killing | 1996 | False | 1995.910034 | 75-79 | Women |
| 141 | 1996-06-06 | Renee Lacey | 63 | Own home | Unlawful killing | 1996 | False | 1995.930054 | 60-64 | Women |
| 142 | 1996-06-10 | Leah Fogg | 82 | Own home | Unlawful killing | 1996 | False | 1995.939941 | 80-84 | Women |
| 143 | 1996-06-17 | Gladys Saunders | 82 | Own home | Unlawful killing | 1996 | False | 1995.959961 | 80-84 | Women |
| 144 | 1996-06-25 | Nellie Bennett | 86 | Own home | Unlawful killing | 1996 | False | 1995.979980 | 85-89 | Women |
| 145 | 1996-06-25 | Margaret Mary Vickers | 81 | Own home | Unlawful killing | 1996 | False | 1995.979980 | 80-84 | Women |
| 146 | 1996-07-02 | Tom Balfour Russell | 77 | Own home | Unlawful killing | 1996 | True | 1996.000000 | 75-79 | Men |
| 147 | 1996-07-11 | Irene Turner | 67 | Own home | Conviction | 1996 | False | 1996.030029 | 65-69 | Women |
| 148 | 1996-07-16 | Carrie Leigh | 81 | Own home | Unlawful killing | 1996 | False | 1996.040039 | 80-84 | Women |
| 149 | 1996-07-19 | Marion Elizabeth Higham | 84 | Own home | Unlawful killing | 1996 | False | 1996.050049 | 80-84 | Women |
| 150 | 1996-07-24 | Elsie Hannible | 85 | Own home | Unlawful killing | 1996 | False | 1996.060059 | 85-89 | Women |
| 151 | 1996-07-29 | Elsie Barker | 84 | Own home | Unlawful killing | 1996 | False | 1996.079956 | 80-84 | Women |
| 152 | 1996-08-30 | Sidney Arthur Smith | 76 | Own home | Unlawful killing | 1996 | True | 1996.160034 | 75-79 | Men |
| 153 | 1996-09-12 | Dorothy Mary Andrew | 85 | Own home | Unlawful killing | 1996 | False | 1996.199951 | 85-89 | Women |
| 154 | 1996-09-20 | Anne Lilian Ralphs | 75 | Own home | Unlawful killing | 1996 | False | 1996.219971 | 75-79 | Women |
| 155 | 1996-10-23 | Millicent Garside | 76 | Own home | Unlawful killing | 1996 | False | 1996.310059 | 75-79 | Women |
| 156 | 1996-11-20 | Irene Heathcote | 76 | Own home | Unlawful killing | 1996 | False | 1996.390015 | 75-79 | Women |
| 157 | 1996-11-23 | Samuel Mills | 89 | Own home | Unlawful killing | 1996 | False | 1996.400024 | 85-89 | Women |
| 158 | 1996-12-04 | Thomas Cheetham | 78 | Own home | Unlawful killing | 1996 | True | 1996.430054 | 75-79 | Men |
| 159 | 1996-12-17 | Kenneth Ernest Smith | 73 | Own home | Unlawful killing | 1996 | True | 1996.459961 | 70-74 | Men |
| 160 | 1997-01-02 | Eileen Daphne Crompton | 75 | Residential home | Unlawful killing | 1997 | False | 1996.510010 | 75-79 | Women |
| 161 | 1997-01-03 | David Alan Harrison | 47 | Own home | Unlawful killing | 1997 | True | 1996.510010 | 45-49 | Men |
| 162 | 1997-01-08 | Elsie Lorna Dean | 69 | Own home | Unlawful killing | 1997 | False | 1996.520020 | 65-69 | Women |
| 163 | 1997-01-20 | Irene Brooder | 76 | Own home | Unlawful killing | 1997 | False | 1996.560059 | 75-79 | Women |
| 164 | 1997-01-27 | Charlotte Bennison | 89 | Own home | Unlawful killing | 1997 | False | 1996.579956 | 85-89 | Women |
| 165 | 1997-02-03 | Charles Henry Killan | 90 | Own home | Unlawful killing | 1997 | False | 1996.589966 | 90-94 | Women |
| 166 | 1997-02-04 | Betty Royston | 70 | Own home | Unlawful killing | 1997 | False | 1996.599976 | 70-74 | Women |
| 167 | 1997-02-23 | Joyce Woodhead | 74 | Own home | Unlawful killing | 1997 | False | 1996.650024 | 70-74 | Women |
| 168 | 1997-02-28 | Lizzie Adams | 77 | Own home | Conviction | 1997 | False | 1996.660034 | 75-79 | Women |
| 169 | 1997-03-22 | Rose Garlick | 76 | Own home | Unlawful killing | 1997 | False | 1996.719971 | 75-79 | Women |
| 170 | 1997-03-27 | May Lowe | 84 | Own home | Unlawful killing | 1997 | False | 1996.739990 | 80-84 | Women |
| 171 | 1997-04-21 | Mary Coutts | 80 | Own home | Unlawful killing | 1997 | False | 1996.810059 | 80-84 | Women |
| 172 | 1997-04-25 | Elsie Cheetham | 76 | Own home | Unlawful killing | 1997 | False | 1996.819946 | 75-79 | Women |
| 173 | 1997-04-25 | Jean Lilley | 58 | Own home | Conviction | 1997 | False | 1996.819946 | 55-59 | Women |
| 174 | 1997-05-02 | Lena Norah Slater | 68 | Own home | Unlawful killing | 1997 | False | 1996.839966 | 65-69 | Women |
| 175 | 1997-05-12 | Ethel May Kellett | 74 | Own home | Unlawful killing | 1997 | False | 1996.859985 | 70-74 | Women |
| 176 | 1997-05-21 | Doris Earls | 79 | Own home | Unlawful killing | 1997 | False | 1996.890015 | 75-79 | Women |
| 177 | 1997-05-29 | Ivy Lomas | 63 | Shipman's surgery | Conviction | 1997 | False | 1996.910034 | 60-64 | Women |
| 178 | 1997-06-24 | Vera Whittingslow | 69 | Own home | Unlawful killing | 1997 | False | 1996.979980 | 65-69 | Women |
| 179 | 1997-07-07 | Maureen Lamonnier Jackson | 51 | Own home | Unlawful killing | 1997 | False | 1997.020020 | 50-54 | Women |
| 180 | 1997-07-14 | Muriel Grimshaw | 76 | Own home | Conviction | 1997 | False | 1997.040039 | 75-79 | Women |
| 181 | 1997-07-25 | John Louden Livesey | 69 | Own home | Unlawful killing | 1997 | True | 1997.069946 | 65-69 | Men |
| 182 | 1997-07-28 | Lily Newby Taylor | 86 | Own home | Unlawful killing | 1997 | False | 1997.069946 | 85-89 | Women |
| 183 | 1997-08-10 | Dorothy Doretta Hopkins | 72 | Own home | Unlawful killing | 1997 | False | 1997.109985 | 70-74 | Women |
| 184 | 1997-09-01 | Nancy Jackson | 81 | Own home | Unlawful killing | 1997 | False | 1997.170044 | 80-84 | Women |
| 185 | 1997-09-22 | Mavis Mary Pickup | 79 | Own home | Unlawful killing | 1997 | False | 1997.229980 | 75-79 | Women |
| 186 | 1997-09-26 | Bessie Swann | 79 | Own home | Unlawful killing | 1997 | False | 1997.239990 | 75-79 | Women |
| 187 | 1997-09-29 | Enid Otter | 77 | Own home | Unlawful killing | 1997 | False | 1997.250000 | 75-79 | Women |
| 188 | 1997-11-10 | Florence Lewis | 79 | Own home | Unlawful killing | 1997 | False | 1997.359985 | 75-79 | Women |
| 189 | 1997-11-14 | Mary Walls | 78 | Own home | Unlawful killing | 1997 | False | 1997.369995 | 75-79 | Women |
| 190 | 1997-11-21 | Elizabeth Mary Baddeley | 83 | Own home | Unlawful killing | 1997 | False | 1997.390015 | 80-84 | Women |
| 191 | 1997-11-24 | Marie Quinn | 67 | Own home | Conviction | 1997 | False | 1997.400024 | 65-69 | Women |
| 192 | 1997-12-08 | Elizabeth Battersby | 70 | Own home | Unlawful killing | 1997 | False | 1997.439941 | 70-74 | Women |
| 193 | 1997-12-09 | Laura Kathleen Wagstaff | 81 | Own home | Conviction | 1997 | False | 1997.439941 | 80-84 | Women |
| 194 | 1997-12-10 | Bianka Pomfret | 49 | Own home | Conviction | 1997 | False | 1997.439941 | 45-49 | Women |
| 195 | 1997-12-18 | Alice Black | 73 | Own home | Unlawful killing | 1997 | False | 1997.469971 | 70-74 | Women |
| 196 | 1997-12-24 | James Joseph King | 83 | Own home | Unlawful killing | 1997 | True | 1997.479980 | 80-84 | Men |
| 197 | 1998-01-22 | Mabel Shawcross | 79 | Own home | Unlawful killing | 1998 | False | 1997.560059 | 75-79 | Women |
| 198 | 1998-01-26 | Norah Nuttall | 64 | Own home | Conviction | 1998 | False | 1997.569946 | 60-64 | Women |
| 199 | 1998-02-02 | Cissie Davies | 73 | Own home | Unlawful killing | 1998 | False | 1997.589966 | 70-74 | Women |
| 200 | 1998-02-09 | Pamela Marguerite Hillier | 68 | Own home | Conviction | 1998 | False | 1997.609985 | 65-69 | Women |
| 201 | 1998-02-13 | Laura Frances Linn | 83 | Own home | Unlawful killing | 1998 | False | 1997.619995 | 80-84 | Women |
| 202 | 1998-02-15 | Irene Berry | 74 | Own home | Unlawful killing | 1998 | False | 1997.630005 | 70-74 | Women |
| 203 | 1998-02-18 | Maureen Alice Ward | 57 | Own home | Conviction | 1998 | False | 1997.640015 | 55-59 | Women |
| 204 | 1998-02-27 | Joan Edwina Dean | 75 | Own home | Unlawful killing | 1998 | False | 1997.660034 | 75-79 | Women |
| 205 | 1998-03-04 | Harold Eddleston | 77 | Own home | Unlawful killing | 1998 | True | 1997.670044 | 75-79 | Men |
| 206 | 1998-03-06 | Margaret Anne Waldron | 65 | Own home | Unlawful killing | 1998 | False | 1997.680054 | 65-69 | Women |
| 207 | 1998-03-07 | Irene Chapman | 74 | Own home | Unlawful killing | 1998 | False | 1997.680054 | 70-74 | Women |
| 208 | 1998-03-13 | Dorothy Long | 84 | Own home | Unlawful killing | 1998 | False | 1997.699951 | 80-84 | Women |
| 209 | 1998-03-17 | Lily Higgins | 83 | Own home | Unlawful killing | 1998 | False | 1997.709961 | 80-84 | Women |
| 210 | 1998-03-20 | Ada Warburton | 77 | Own home | Unlawful killing | 1998 | False | 1997.719971 | 75-79 | Women |
| 211 | 1998-03-24 | Martha Marley | 88 | Own home | Unlawful killing | 1998 | False | 1997.729980 | 85-89 | Women |
| 212 | 1998-05-11 | Winifred Mellor | 73 | Own home | Conviction | 1998 | False | 1997.859985 | 70-74 | Women |
| 213 | 1998-06-12 | Joan May Melia | 73 | Own home | Conviction | 1998 | False | 1997.949951 | 70-74 | Women |
| 214 | 1998-06-24 | Kathleen Grundy | 81 | Own home | Conviction | 1998 | False | 1997.979980 | 80-84 | Women |
This part of the dataset describes the gender of the victims that Dr. Shipman killed.
query = """
SELECt age, gender2,count(*) as amount
FROM [practical_sql].[dbo].[shipman_confirmed_victims]
group by age,gender2
order by count(*) desc
"""
df = pd.read_sql_query(query, conn)
df
| age | gender2 | amount | |
|---|---|---|---|
| 0 | 84 | Women | 12 |
| 1 | 74 | Women | 11 |
| 2 | 81 | Women | 11 |
| 3 | 76 | Women | 9 |
| 4 | 77 | Women | 8 |
| 5 | 79 | Women | 8 |
| 6 | 73 | Women | 8 |
| 7 | 82 | Women | 8 |
| 8 | 75 | Women | 7 |
| 9 | 69 | Women | 7 |
| 10 | 70 | Women | 7 |
| 11 | 80 | Women | 7 |
| 12 | 78 | Women | 6 |
| 13 | 83 | Women | 6 |
| 14 | 85 | Women | 5 |
| 15 | 86 | Women | 5 |
| 16 | 87 | Women | 5 |
| 17 | 88 | Women | 5 |
| 18 | 71 | Women | 4 |
| 19 | 72 | Women | 4 |
| 20 | 68 | Women | 4 |
| 21 | 77 | Men | 4 |
| 22 | 85 | Men | 4 |
| 23 | 63 | Women | 4 |
| 24 | 67 | Women | 3 |
| 25 | 88 | Men | 3 |
| 26 | 82 | Men | 3 |
| 27 | 90 | Women | 3 |
| 28 | 89 | Women | 2 |
| 29 | 83 | Men | 2 |
| 30 | 73 | Men | 2 |
| 31 | 76 | Men | 2 |
| 32 | 81 | Men | 2 |
| 33 | 90 | Men | 2 |
| 34 | 51 | Women | 2 |
| 35 | 53 | Women | 2 |
| 36 | 54 | Women | 2 |
| 37 | 65 | Women | 2 |
| 38 | 57 | Women | 2 |
| 39 | 58 | Women | 1 |
| 40 | 59 | Women | 1 |
| 41 | 60 | Women | 1 |
| 42 | 64 | Women | 1 |
| 43 | 56 | Women | 1 |
| 44 | 47 | Women | 1 |
| 45 | 49 | Women | 1 |
| 46 | 75 | Men | 1 |
| 47 | 86 | Men | 1 |
| 48 | 87 | Men | 1 |
| 49 | 78 | Men | 1 |
| 50 | 79 | Men | 1 |
| 51 | 80 | Men | 1 |
| 52 | 41 | Men | 1 |
| 53 | 43 | Men | 1 |
| 54 | 47 | Men | 1 |
| 55 | 67 | Men | 1 |
| 56 | 69 | Men | 1 |
| 57 | 70 | Men | 1 |
| 58 | 72 | Men | 1 |
| 59 | 92 | Women | 1 |
| 60 | 93 | Women | 1 |
import plotly.express as px
gender= df['gender2']
age=df['age']
fig = px.pie(values=age, names=gender)
fig.update_layout(
title=dict(text="Shipman's prefered victims were Women"), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()
Most of Shipman's victims were killed in the 1990s.
query = """
SELECT yearofDeath,count(yearofDeath) as number
FROM [practical_sql].[dbo].[shipman_confirmed_victims]
group by yearofDeath
"""
df = pd.read_sql_query(query, conn)
df
| yearofDeath | number | |
|---|---|---|
| 0 | 1975 | 1 |
| 1 | 1978 | 4 |
| 2 | 1979 | 2 |
| 3 | 1981 | 2 |
| 4 | 1983 | 2 |
| 5 | 1984 | 9 |
| 6 | 1985 | 11 |
| 7 | 1986 | 8 |
| 8 | 1987 | 8 |
| 9 | 1988 | 11 |
| 10 | 1989 | 12 |
| 11 | 1990 | 2 |
| 12 | 1992 | 1 |
| 13 | 1993 | 16 |
| 14 | 1994 | 11 |
| 15 | 1995 | 30 |
| 16 | 1996 | 30 |
| 17 | 1997 | 37 |
| 18 | 1998 | 18 |
import numpy
import plotly.express as px
# Random Data
names = df['yearofDeath']
x = df['number']
fig = px.pie(values=x, names=names)
fig.update_layout(
title=dict(text="Years when Shipman killed most of his victims."),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()
Shipman preferred place to kill his victims was their own home.
query = """
SELECT placeofdeath, count(placeofdeath) as [amount of deaths]
FROM [practical_sql].[dbo].[shipman_confirmed_victims]
group by PlaceofDeath
order by count(placeofdeath) desc
"""
df = pd.read_sql_query(query, conn)
df
| placeofdeath | amount of deaths | |
|---|---|---|
| 0 | Own home | 204 |
| 1 | Shipman's surgery | 6 |
| 2 | Residential Home | 2 |
| 3 | Hospital | 2 |
| 4 | Nursing home | 1 |
import numpy
import plotly.express as px
# Random Data
names = df['placeofdeath']
x = df['amount of deaths']
fig = px.pie(values=x, names=names)
fig.update_layout(
title=dict(text="Shipman killed most of his victims in their own home."), font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightblue")
fig.show()
Most of the Shipman's victims were between the ages of 60-85.
query = """
SELECt age, gender2,count(*) as amount
FROM [practical_sql].[dbo].[shipman_confirmed_victims]
group by age,gender2
order by count(*) desc
"""
df = pd.read_sql_query(query, conn)
df
| age | gender2 | amount | |
|---|---|---|---|
| 0 | 84 | Women | 12 |
| 1 | 74 | Women | 11 |
| 2 | 81 | Women | 11 |
| 3 | 76 | Women | 9 |
| 4 | 77 | Women | 8 |
| 5 | 79 | Women | 8 |
| 6 | 73 | Women | 8 |
| 7 | 82 | Women | 8 |
| 8 | 75 | Women | 7 |
| 9 | 69 | Women | 7 |
| 10 | 70 | Women | 7 |
| 11 | 80 | Women | 7 |
| 12 | 78 | Women | 6 |
| 13 | 83 | Women | 6 |
| 14 | 85 | Women | 5 |
| 15 | 86 | Women | 5 |
| 16 | 87 | Women | 5 |
| 17 | 88 | Women | 5 |
| 18 | 71 | Women | 4 |
| 19 | 72 | Women | 4 |
| 20 | 68 | Women | 4 |
| 21 | 77 | Men | 4 |
| 22 | 85 | Men | 4 |
| 23 | 63 | Women | 4 |
| 24 | 67 | Women | 3 |
| 25 | 88 | Men | 3 |
| 26 | 82 | Men | 3 |
| 27 | 90 | Women | 3 |
| 28 | 89 | Women | 2 |
| 29 | 83 | Men | 2 |
| 30 | 73 | Men | 2 |
| 31 | 76 | Men | 2 |
| 32 | 81 | Men | 2 |
| 33 | 90 | Men | 2 |
| 34 | 51 | Women | 2 |
| 35 | 53 | Women | 2 |
| 36 | 54 | Women | 2 |
| 37 | 65 | Women | 2 |
| 38 | 57 | Women | 2 |
| 39 | 58 | Women | 1 |
| 40 | 59 | Women | 1 |
| 41 | 60 | Women | 1 |
| 42 | 64 | Women | 1 |
| 43 | 56 | Women | 1 |
| 44 | 47 | Women | 1 |
| 45 | 49 | Women | 1 |
| 46 | 75 | Men | 1 |
| 47 | 86 | Men | 1 |
| 48 | 87 | Men | 1 |
| 49 | 78 | Men | 1 |
| 50 | 79 | Men | 1 |
| 51 | 80 | Men | 1 |
| 52 | 41 | Men | 1 |
| 53 | 43 | Men | 1 |
| 54 | 47 | Men | 1 |
| 55 | 67 | Men | 1 |
| 56 | 69 | Men | 1 |
| 57 | 70 | Men | 1 |
| 58 | 72 | Men | 1 |
| 59 | 92 | Women | 1 |
| 60 | 93 | Women | 1 |
import plotly.express as px
age, gender = df["age"],df["gender2"]
fig = px.box(y = age, x=gender, points="all")
fig.update_layout(
title=dict(text="Shipman's preferred victims were old old people"),font=dict(size=15)
)
fig.update_layout(paper_bgcolor="lightpink",plot_bgcolor = "rgba(0,0,0,0)")
fig.update_layout(
xaxis_title="Months",
yaxis_title="Years ",
legend_title="Legend Title"
)
fig.show()
query = """
SELECT YEAR([DateofDeath]) AS Year,
FORMAT([DateofDeath], 'MMMM') AS Month,
day([DateofDeath]) AS Day,
*
from [dbo].[shipman_confirmed_victims]
"""
df = pd.read_sql_query(query, conn)
df
| Year | Month | Day | DateofDeath | Name | Age | PlaceofDeath | Decision | yearOfDeath | gender | fractionalDeathYear | ageBracket | gender2 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1975 | March | 17 | 1975-03-17 | Eva Lyons | 70 | Own home | Unlawful killing | 1975 | False | 1974.709961 | 70-74 | Women |
| 1 | 1978 | August | 7 | 1978-08-07 | Sarah Hannah Marsland | 86 | Own home | Unlawful killing | 1978 | False | 1978.099976 | 85-89 | Women |
| 2 | 1978 | August | 30 | 1978-08-30 | Mary Ellen Jordan | 73 | Own home | Unlawful killing | 1978 | False | 1978.160034 | 70-74 | Women |
| 3 | 1978 | December | 7 | 1978-12-07 | Harold Bramwell | 73 | Own home | Unlawful killing | 1978 | True | 1978.439941 | 70-74 | Men |
| 4 | 1978 | December | 20 | 1978-12-20 | Annie Campbell | 88 | Own home | Unlawful killing | 1978 | False | 1978.469971 | 85-89 | Women |
| 5 | 1979 | August | 10 | 1979-08-10 | Alice Maude Gorton | 76 | Own home | Unlawful killing | 1979 | False | 1979.109985 | 75-79 | Women |
| 6 | 1979 | November | 28 | 1979-11-28 | Jack Leslie Shelmerdine | 77 | Hospital | Unlawful killing | 1979 | True | 1979.410034 | 75-79 | Men |
| 7 | 1981 | April | 18 | 1981-04-18 | May Slater | 84 | Own home | Unlawful killing | 1981 | False | 1980.800049 | 80-84 | Women |
| 8 | 1981 | August | 26 | 1981-08-26 | Elizabeth Ashworth | 81 | Own home | Unlawful killing | 1981 | False | 1981.150024 | 80-84 | Women |
| 9 | 1983 | January | 4 | 1983-01-04 | Percy Ward | 90 | Own home | Unlawful killing | 1983 | True | 1982.510010 | 90-94 | Men |
| 10 | 1983 | June | 28 | 1983-06-28 | Moira Ashton Fox | 77 | Own home | Unlawful killing | 1983 | False | 1982.989990 | 75-79 | Women |
| 11 | 1984 | January | 7 | 1984-01-07 | Dorothy Tucker | 51 | Own home | Unlawful killing | 1984 | False | 1983.520020 | 50-54 | Women |
| 12 | 1984 | February | 8 | 1984-02-08 | Gladys Roberts | 78 | Own home | Unlawful killing | 1984 | False | 1983.609985 | 75-79 | Women |
| 13 | 1984 | April | 15 | 1984-04-15 | Joseph Bardsley | 83 | Own home | Unlawful killing | 1984 | True | 1983.790039 | 80-84 | Men |
| 14 | 1984 | April | 24 | 1984-04-24 | Winifred Arrowsmith | 70 | Own home | Unlawful killing | 1984 | False | 1983.810059 | 70-74 | Women |
| 15 | 1984 | September | 21 | 1984-09-21 | Mary Winterbottom | 76 | Own home | Unlawful killing | 1984 | False | 1984.219971 | 75-79 | Women |
| 16 | 1984 | November | 27 | 1984-11-27 | Ada Ashworth | 87 | Own home | Unlawful killing | 1984 | False | 1984.410034 | 85-89 | Women |
| 17 | 1984 | December | 17 | 1984-12-17 | Joseph Vincent Everall | 80 | Own home | Unlawful killing | 1984 | True | 1984.459961 | 80-84 | Men |
| 18 | 1984 | December | 18 | 1984-12-18 | Edith Wibberley | 76 | Own home | Unlawful killing | 1984 | False | 1984.469971 | 75-79 | Women |
| 19 | 1984 | December | 24 | 1984-12-24 | Eileen Theresa Cox | 72 | Own home | Unlawful killing | 1984 | False | 1984.479980 | 70-74 | Women |
| 20 | 1985 | January | 2 | 1985-01-02 | Peter Lewis | 41 | Own home | Unlawful killing | 1985 | True | 1984.510010 | 40-44 | Men |
| 21 | 1985 | February | 1 | 1985-02-01 | May Brookes | 74 | Own home | Unlawful killing | 1985 | False | 1984.589966 | 70-74 | Women |
| 22 | 1985 | February | 4 | 1985-02-04 | Ellen Higson | 84 | Own home | Unlawful killing | 1985 | False | 1984.599976 | 80-84 | Women |
| 23 | 1985 | February | 15 | 1985-02-15 | Margaret Ann Conway | 69 | Own home | Unlawful killing | 1985 | False | 1984.630005 | 65-69 | Women |
| 24 | 1985 | February | 22 | 1985-02-22 | Kathleen McDonald | 73 | Own home | Unlawful killing | 1985 | False | 1984.650024 | 70-74 | Women |
| 25 | 1985 | June | 26 | 1985-06-26 | Thomas Moult | 70 | Own home | Unlawful killing | 1985 | True | 1984.989990 | 70-74 | Men |
| 26 | 1985 | June | 26 | 1985-06-26 | Mildred Robinson | 84 | Own home | Unlawful killing | 1985 | False | 1984.989990 | 80-84 | Women |
| 27 | 1985 | August | 23 | 1985-08-23 | Frances Elizabeth Turner | 85 | Own home | Unlawful killing | 1985 | False | 1985.150024 | 85-89 | Women |
| 28 | 1985 | December | 17 | 1985-12-17 | Selina Mackenzie | 77 | Own home | Unlawful killing | 1985 | False | 1985.459961 | 75-79 | Women |
| 29 | 1985 | December | 20 | 1985-12-20 | Vera Bramwell | 79 | Own home | Unlawful killing | 1985 | False | 1985.469971 | 75-79 | Women |
| 30 | 1985 | December | 31 | 1985-12-31 | Fred Kellett | 79 | Own home | Unlawful killing | 1985 | True | 1985.500000 | 75-79 | Men |
| 31 | 1986 | January | 7 | 1986-01-07 | Deborah Middleton | 81 | Own home | Unlawful killing | 1986 | False | 1985.520020 | 80-84 | Women |
| 32 | 1986 | April | 23 | 1986-04-23 | Dorothy Fletcher | 74 | Residential Home | Unlawful killing | 1986 | False | 1985.810059 | 70-74 | Women |
| 33 | 1986 | June | 6 | 1986-06-06 | Thomas Fowden | 81 | Own home | Unlawful killing | 1986 | True | 1985.930054 | 80-84 | Men |
| 34 | 1986 | September | 15 | 1986-09-15 | Mona Ashton White | 63 | Own home | Unlawful killing | 1986 | False | 1986.209961 | 60-64 | Women |
| 35 | 1986 | October | 7 | 1986-10-07 | Mary Tomlin | 73 | Own home | Unlawful killing | 1986 | False | 1986.270020 | 70-74 | Women |
| 36 | 1986 | November | 17 | 1986-11-17 | Beatrice Toft | 59 | Own home | Unlawful killing | 1986 | False | 1986.380005 | 55-59 | Women |
| 37 | 1986 | December | 16 | 1986-12-16 | Lily Broadbent | 75 | Own home | Unlawful killing | 1986 | False | 1986.459961 | 75-79 | Women |
| 38 | 1986 | December | 23 | 1986-12-23 | James Wood | 82 | Own home | Unlawful killing | 1986 | True | 1986.479980 | 80-84 | Men |
| 39 | 1987 | March | 30 | 1987-03-30 | Frank Halliday | 76 | Own home | Unlawful killing | 1987 | True | 1986.750000 | 75-79 | Men |
| 40 | 1987 | April | 1 | 1987-04-01 | Albert Cheetham | 85 | Own home | Unlawful killing | 1987 | True | 1986.750000 | 85-89 | Men |
| 41 | 1987 | April | 16 | 1987-04-16 | Alice Thomas | 83 | Own home | Unlawful killing | 1987 | False | 1986.790039 | 80-84 | Women |
| 42 | 1987 | May | 8 | 1987-05-08 | Jane Frances Rostron | 78 | Own home | Unlawful killing | 1987 | False | 1986.849976 | 75-79 | Women |
| 43 | 1987 | September | 14 | 1987-09-14 | Nancy Anne Brassington | 71 | Own home | Unlawful killing | 1987 | False | 1987.209961 | 70-74 | Women |
| 44 | 1987 | December | 11 | 1987-12-11 | Margaret Townsend | 80 | Own home | Unlawful killing | 1987 | False | 1987.449951 | 80-84 | Women |
| 45 | 1987 | December | 29 | 1987-12-29 | Nellie Bardsley | 69 | Own home | Unlawful killing | 1987 | False | 1987.500000 | 65-69 | Women |
| 46 | 1987 | December | 30 | 1987-12-30 | Elizabeth Ann Rogers | 74 | Own home | Unlawful killing | 1987 | False | 1987.500000 | 70-74 | Women |
| 47 | 1988 | January | 5 | 1988-01-05 | Elizabeth Fletcher | 90 | Own home | Unlawful killing | 1988 | False | 1987.510010 | 90-94 | Women |
| 48 | 1988 | January | 15 | 1988-01-15 | Alice Mary Jones | 83 | Own home | Unlawful killing | 1988 | False | 1987.540039 | 80-84 | Women |
| 49 | 1988 | February | 9 | 1988-02-09 | Dorothea Hill Renwick | 90 | Own home | Unlawful killing | 1988 | False | 1987.609985 | 90-94 | Women |
| 50 | 1988 | February | 15 | 1988-02-15 | Ann Cooper | 93 | Own home | Unlawful killing | 1988 | False | 1987.619995 | 90-94 | Women |
| 51 | 1988 | February | 15 | 1988-02-15 | Jane Jones | 83 | Own home | Unlawful killing | 1988 | False | 1987.619995 | 80-84 | Women |
| 52 | 1988 | February | 16 | 1988-02-16 | Lavinia Robinson | 84 | Own home | Unlawful killing | 1988 | False | 1987.630005 | 80-84 | Women |
| 53 | 1988 | September | 18 | 1988-09-18 | Rose Ann Adshead | 80 | Own home | Unlawful killing | 1988 | False | 1988.219971 | 80-84 | Women |
| 54 | 1988 | October | 20 | 1988-10-20 | Alice Prestwich | 69 | Own home | Unlawful killing | 1988 | False | 1988.300049 | 65-69 | Women |
| 55 | 1988 | November | 6 | 1988-11-06 | Walter Tingle | 85 | Own home | Unlawful killing | 1988 | True | 1988.349976 | 85-89 | Men |
| 56 | 1988 | December | 17 | 1988-12-17 | Harry Stafford | 87 | Own home | Unlawful killing | 1988 | True | 1988.459961 | 85-89 | Men |
| 57 | 1988 | December | 19 | 1988-12-19 | Ethel Bennett | 80 | Own home | Unlawful killing | 1988 | False | 1988.469971 | 80-84 | Women |
| 58 | 1989 | January | 31 | 1989-01-31 | Wilfred Chappell | 80 | Own home | Unlawful killing | 1989 | False | 1988.589966 | 80-84 | Women |
| 59 | 1989 | March | 8 | 1989-03-08 | Mary Emma Hamer | 81 | Shipman's surgery | Unlawful killing | 1989 | False | 1988.680054 | 80-84 | Women |
| 60 | 1989 | May | 12 | 1989-05-12 | Beatrice Helen Clee | 78 | Own home | Unlawful killing | 1989 | False | 1988.859985 | 75-79 | Women |
| 61 | 1989 | June | 5 | 1989-06-05 | Josephine Hall | 69 | Own home | Unlawful killing | 1989 | False | 1988.930054 | 65-69 | Women |
| 62 | 1989 | July | 6 | 1989-07-06 | Hilda Fitton | 75 | Own home | Unlawful killing | 1989 | False | 1989.010010 | 75-79 | Women |
| 63 | 1989 | August | 14 | 1989-08-14 | Marion Carradice | 80 | Own home | Unlawful killing | 1989 | False | 1989.119995 | 80-84 | Women |
| 64 | 1989 | September | 22 | 1989-09-22 | Elsie Harrop | 82 | Own home | Unlawful killing | 1989 | False | 1989.229980 | 80-84 | Women |
| 65 | 1989 | September | 26 | 1989-09-26 | Elizabeth Mary Burke | 82 | Own home | Unlawful killing | 1989 | False | 1989.239990 | 80-84 | Women |
| 66 | 1989 | October | 15 | 1989-10-15 | Sarah Jane Williamson | 82 | Own home | Unlawful killing | 1989 | False | 1989.290039 | 80-84 | Women |
| 67 | 1989 | October | 16 | 1989-10-16 | John Charlton | 81 | Own home | Unlawful killing | 1989 | True | 1989.290039 | 80-84 | Men |
| 68 | 1989 | October | 18 | 1989-10-18 | George Edgar Vizor | 67 | Own home | Unlawful killing | 1989 | True | 1989.300049 | 65-69 | Men |
| 69 | 1989 | November | 6 | 1989-11-06 | Joseph Frank Wilcockson | 85 | Own home | Unlawful killing | 1989 | True | 1989.349976 | 85-89 | Men |
| 70 | 1990 | September | 18 | 1990-09-18 | Dorothy Rowarth | 56 | Own home | Unlawful killing | 1990 | False | 1990.219971 | 55-59 | Women |
| 71 | 1990 | December | 30 | 1990-12-30 | Mary Rose Dudley | 69 | Own home | Unlawful killing | 1990 | False | 1990.500000 | 65-69 | Women |
| 72 | 1992 | October | 7 | 1992-10-07 | Monica Rene Sparkes | 72 | Own home | Unlawful killing | 1992 | False | 1992.270020 | 70-74 | Women |
| 73 | 1993 | February | 24 | 1993-02-24 | Olive Heginbotham | 86 | Own home | Unlawful killing | 1993 | False | 1992.650024 | 85-89 | Women |
| 74 | 1993 | February | 24 | 1993-02-24 | Hilda Mary Couzens | 92 | Own home | Unlawful killing | 1993 | False | 1992.650024 | 90-94 | Women |
| 75 | 1993 | March | 22 | 1993-03-22 | Amy Whitehead | 82 | Own home | Unlawful killing | 1993 | False | 1992.719971 | 80-84 | Women |
| 76 | 1993 | April | 8 | 1993-04-08 | Mary Emma Andrew | 86 | Own home | Unlawful killing | 1993 | False | 1992.770020 | 85-89 | Women |
| 77 | 1993 | April | 17 | 1993-04-17 | Sarah Ashworth | 74 | Own home | Unlawful killing | 1993 | False | 1992.790039 | 70-74 | Women |
| 78 | 1993 | April | 26 | 1993-04-26 | Fanny Nichols | 84 | Own home | Unlawful killing | 1993 | False | 1992.819946 | 80-84 | Women |
| 79 | 1993 | April | 27 | 1993-04-27 | Marjorie Parker | 74 | Own home | Unlawful killing | 1993 | False | 1992.819946 | 70-74 | Women |
| 80 | 1993 | May | 2 | 1993-05-02 | Nellie Mullen | 77 | Own home | Unlawful killing | 1993 | False | 1992.839966 | 75-79 | Women |
| 81 | 1993 | May | 4 | 1993-05-04 | Edna May Llewellyn | 68 | Own home | Unlawful killing | 1993 | False | 1992.839966 | 65-69 | Women |
| 82 | 1993 | May | 12 | 1993-05-12 | Emily Morgan | 84 | Own home | Unlawful killing | 1993 | False | 1992.859985 | 80-84 | Women |
| 83 | 1993 | May | 13 | 1993-05-13 | Violet May Bird | 60 | Own home | Unlawful killing | 1993 | False | 1992.869995 | 60-64 | Women |
| 84 | 1993 | July | 22 | 1993-07-22 | Jose Kathleen Diana Richards | 74 | Own home | Unlawful killing | 1993 | False | 1993.060059 | 70-74 | Women |
| 85 | 1993 | August | 16 | 1993-08-16 | Edith Calverley | 77 | Own home | Unlawful killing | 1993 | False | 1993.130005 | 75-79 | Women |
| 86 | 1993 | December | 16 | 1993-12-16 | Joseph Leigh | 78 | Own home | Unlawful killing | 1993 | False | 1993.459961 | 75-79 | Women |
| 87 | 1993 | December | 22 | 1993-12-22 | Eileen Robinson | 54 | Own home | Unlawful killing | 1993 | False | 1993.479980 | 50-54 | Women |
| 88 | 1993 | December | 31 | 1993-12-31 | Charles Edward Brocklehurst | 90 | Own home | Unlawful killing | 1993 | True | 1993.500000 | 90-94 | Men |
| 89 | 1994 | January | 4 | 1994-01-04 | Joan Milray Harding | 82 | Shipman's surgery | Unlawful killing | 1994 | False | 1993.510010 | 80-84 | Women |
| 90 | 1994 | January | 13 | 1994-01-13 | Christine Hancock | 53 | Own home | Unlawful killing | 1994 | False | 1993.540039 | 50-54 | Women |
| 91 | 1994 | February | 9 | 1994-02-09 | Elsie Platt | 73 | Own home | Unlawful killing | 1994 | False | 1993.609985 | 70-74 | Women |
| 92 | 1994 | May | 17 | 1994-05-17 | Mary Alice Smith | 84 | Own home | Unlawful killing | 1994 | False | 1993.880005 | 80-84 | Women |
| 93 | 1994 | May | 25 | 1994-05-25 | Ronnie Devenport | 57 | Own home | Unlawful killing | 1994 | False | 1993.900024 | 55-59 | Women |
| 94 | 1994 | June | 15 | 1994-06-15 | Cicely Sharples | 87 | Own home | Unlawful killing | 1994 | False | 1993.959961 | 85-89 | Women |
| 95 | 1994 | June | 17 | 1994-06-17 | Alice Christine Kitchen | 70 | Own home | Unlawful killing | 1994 | False | 1993.959961 | 70-74 | Women |
| 96 | 1994 | July | 27 | 1994-07-27 | Maria Thornton | 78 | Own home | Unlawful killing | 1994 | False | 1994.069946 | 75-79 | Women |
| 97 | 1994 | November | 25 | 1994-11-25 | Henrietta Walker | 87 | Own home | Unlawful killing | 1994 | False | 1994.400024 | 85-89 | Women |
| 98 | 1994 | November | 30 | 1994-11-30 | Elizabeth Ellen Mellor | 75 | Own home | Unlawful killing | 1994 | False | 1994.420044 | 75-79 | Women |
| 99 | 1994 | December | 29 | 1994-12-29 | John Bennett Molesdale | 81 | Own home | Unlawful killing | 1994 | False | 1994.500000 | 80-84 | Women |
| 100 | 1995 | January | 9 | 1995-01-09 | Alice Kennedy | 88 | Own home | Unlawful killing | 1995 | False | 1994.530029 | 85-89 | Women |
| 101 | 1995 | March | 1 | 1995-03-01 | Lucy Virgin | 70 | Own home | Unlawful killing | 1995 | False | 1994.670044 | 70-74 | Women |
| 102 | 1995 | March | 3 | 1995-03-03 | Joseph Shaw | 88 | Own home | Unlawful killing | 1995 | True | 1994.670044 | 85-89 | Men |
| 103 | 1995 | March | 6 | 1995-03-06 | Maria West | 81 | Own home | Conviction | 1995 | False | 1994.680054 | 80-84 | Women |
| 104 | 1995 | March | 7 | 1995-03-07 | Netta Ashcroft | 71 | Own home | Unlawful killing | 1995 | False | 1994.680054 | 70-74 | Women |
| 105 | 1995 | March | 7 | 1995-03-07 | Lily Bardsley | 88 | Own home | Unlawful killing | 1995 | False | 1994.680054 | 85-89 | Women |
| 106 | 1995 | March | 13 | 1995-03-13 | Marie Antoinette Fernley | 53 | Own home | Unlawful killing | 1995 | False | 1994.699951 | 50-54 | Women |
| 107 | 1995 | March | 21 | 1995-03-21 | John Crompton | 82 | Own home | Unlawful killing | 1995 | True | 1994.719971 | 80-84 | Men |
| 108 | 1995 | March | 26 | 1995-03-26 | Frank Crompton | 86 | Own home | Unlawful killing | 1995 | True | 1994.729980 | 85-89 | Men |
| 109 | 1995 | March | 31 | 1995-03-31 | Vera Brocklehurst | 70 | Own home | Unlawful killing | 1995 | False | 1994.750000 | 70-74 | Women |
| 110 | 1995 | April | 10 | 1995-04-10 | Angela Philomena Tierney | 71 | Own home | Unlawful killing | 1995 | False | 1994.780029 | 70-74 | Women |
| 111 | 1995 | April | 13 | 1995-04-13 | Edith Scott | 85 | Own home | Unlawful killing | 1995 | False | 1994.780029 | 85-89 | Women |
| 112 | 1995 | April | 14 | 1995-04-14 | Clara Hackney | 84 | Own home | Unlawful killing | 1995 | False | 1994.790039 | 80-84 | Women |
| 113 | 1995 | April | 21 | 1995-04-21 | Renate Eldtraude Overton | 47 | Hospital | Unlawful killing | 1995 | False | 1994.810059 | 45-49 | Women |
| 114 | 1995 | May | 4 | 1995-05-04 | Kate Maud Sellors | 75 | Own home | Unlawful killing | 1995 | False | 1994.839966 | 75-79 | Women |
| 115 | 1995 | June | 2 | 1995-06-02 | Clifford Barnes Heapey | 85 | Nursing home | Unlawful killing | 1995 | True | 1994.920044 | 85-89 | Men |
| 116 | 1995 | June | 13 | 1995-06-13 | Bertha Moss | 68 | Shipman's surgery | Unlawful killing | 1995 | False | 1994.949951 | 65-69 | Women |
| 117 | 1995 | June | 17 | 1995-06-17 | Brenda Ashworth | 63 | Own home | Unlawful killing | 1995 | False | 1994.959961 | 60-64 | Women |
| 118 | 1995 | June | 29 | 1995-06-29 | Ernest Rudol | 82 | Own home | Unlawful killing | 1995 | False | 1994.989990 | 80-84 | Women |
| 119 | 1995 | July | 12 | 1995-07-12 | Ada Matley Hilton | 88 | Own home | Unlawful killing | 1995 | False | 1995.030029 | 85-89 | Women |
| 120 | 1995 | July | 31 | 1995-07-31 | Irene Aitken | 65 | Own home | Unlawful killing | 1995 | False | 1995.079956 | 65-69 | Women |
| 121 | 1995 | August | 29 | 1995-08-29 | Arthur Henderson Stopford | 82 | Own home | Unlawful killing | 1995 | True | 1995.160034 | 80-84 | Men |
| 122 | 1995 | September | 14 | 1995-09-14 | Geoffrey Bogle | 72 | Own home | Unlawful killing | 1995 | True | 1995.209961 | 70-74 | Men |
| 123 | 1995 | September | 26 | 1995-09-26 | Dora Elizabeth Ashton | 87 | Shipman's surgery | Unlawful killing | 1995 | False | 1995.239990 | 85-89 | Women |
| 124 | 1995 | October | 24 | 1995-10-24 | Muriel Margaret Ward | 87 | Own home | Unlawful killing | 1995 | False | 1995.319946 | 85-89 | Women |
| 125 | 1995 | November | 8 | 1995-11-08 | Edith Brock | 74 | Own home | Unlawful killing | 1995 | False | 1995.359985 | 70-74 | Women |
| 126 | 1995 | November | 22 | 1995-11-22 | Charles Henry Barlow | 88 | Own home | Unlawful killing | 1995 | True | 1995.390015 | 85-89 | Men |
| 127 | 1995 | November | 25 | 1995-11-25 | Konrad Peter Ovcar-Robinson | 43 | Own home | Unlawful killing | 1995 | True | 1995.400024 | 40-44 | Men |
| 128 | 1995 | December | 14 | 1995-12-14 | Elizabeth Teresa Sigley | 67 | Own home | Unlawful killing | 1995 | False | 1995.449951 | 65-69 | Women |
| 129 | 1995 | December | 14 | 1995-12-14 | Kenneth Wharmby Woodhead | 75 | Own home | Unlawful killing | 1995 | True | 1995.449951 | 75-79 | Men |
| 130 | 1996 | January | 2 | 1996-01-02 | Hilda Mary Hibbert | 81 | Own home | Unlawful killing | 1996 | False | 1995.500000 | 80-84 | Women |
| 131 | 1996 | January | 11 | 1996-01-11 | Erla Copeland | 79 | Own home | Unlawful killing | 1996 | False | 1995.530029 | 75-79 | Women |
| 132 | 1996 | February | 21 | 1996-02-21 | Jane Elizabeth Shelmerdine | 80 | Own home | Unlawful killing | 1996 | False | 1995.640015 | 80-84 | Women |
| 133 | 1996 | February | 27 | 1996-02-27 | John Sheard Greenhalgh | 88 | Own home | Unlawful killing | 1996 | True | 1995.660034 | 85-89 | Men |
| 134 | 1996 | March | 12 | 1996-03-12 | Minnie Doris Irene Galpin | 71 | Own home | Unlawful killing | 1996 | False | 1995.699951 | 70-74 | Women |
| 135 | 1996 | April | 18 | 1996-04-18 | Marjorie Hope Waller | 79 | Own home | Unlawful killing | 1996 | False | 1995.800049 | 75-79 | Women |
| 136 | 1996 | April | 24 | 1996-04-24 | John Stone | 77 | Own home | Unlawful killing | 1996 | True | 1995.810059 | 75-79 | Men |
| 137 | 1996 | May | 7 | 1996-05-07 | Elsie Godfrey | 85 | Own home | Unlawful killing | 1996 | False | 1995.849976 | 85-89 | Women |
| 138 | 1996 | May | 13 | 1996-05-13 | Edith Brady | 72 | Shipman's surgery | Unlawful killing | 1996 | False | 1995.869995 | 70-74 | Women |
| 139 | 1996 | May | 29 | 1996-05-29 | Valerie Cuthbert | 54 | Own home | Unlawful killing | 1996 | False | 1995.910034 | 50-54 | Women |
| 140 | 1996 | May | 30 | 1996-05-30 | Lilian Cullen | 77 | Own home | Unlawful killing | 1996 | False | 1995.910034 | 75-79 | Women |
| 141 | 1996 | June | 6 | 1996-06-06 | Renee Lacey | 63 | Own home | Unlawful killing | 1996 | False | 1995.930054 | 60-64 | Women |
| 142 | 1996 | June | 10 | 1996-06-10 | Leah Fogg | 82 | Own home | Unlawful killing | 1996 | False | 1995.939941 | 80-84 | Women |
| 143 | 1996 | June | 17 | 1996-06-17 | Gladys Saunders | 82 | Own home | Unlawful killing | 1996 | False | 1995.959961 | 80-84 | Women |
| 144 | 1996 | June | 25 | 1996-06-25 | Nellie Bennett | 86 | Own home | Unlawful killing | 1996 | False | 1995.979980 | 85-89 | Women |
| 145 | 1996 | June | 25 | 1996-06-25 | Margaret Mary Vickers | 81 | Own home | Unlawful killing | 1996 | False | 1995.979980 | 80-84 | Women |
| 146 | 1996 | July | 2 | 1996-07-02 | Tom Balfour Russell | 77 | Own home | Unlawful killing | 1996 | True | 1996.000000 | 75-79 | Men |
| 147 | 1996 | July | 11 | 1996-07-11 | Irene Turner | 67 | Own home | Conviction | 1996 | False | 1996.030029 | 65-69 | Women |
| 148 | 1996 | July | 16 | 1996-07-16 | Carrie Leigh | 81 | Own home | Unlawful killing | 1996 | False | 1996.040039 | 80-84 | Women |
| 149 | 1996 | July | 19 | 1996-07-19 | Marion Elizabeth Higham | 84 | Own home | Unlawful killing | 1996 | False | 1996.050049 | 80-84 | Women |
| 150 | 1996 | July | 24 | 1996-07-24 | Elsie Hannible | 85 | Own home | Unlawful killing | 1996 | False | 1996.060059 | 85-89 | Women |
| 151 | 1996 | July | 29 | 1996-07-29 | Elsie Barker | 84 | Own home | Unlawful killing | 1996 | False | 1996.079956 | 80-84 | Women |
| 152 | 1996 | August | 30 | 1996-08-30 | Sidney Arthur Smith | 76 | Own home | Unlawful killing | 1996 | True | 1996.160034 | 75-79 | Men |
| 153 | 1996 | September | 12 | 1996-09-12 | Dorothy Mary Andrew | 85 | Own home | Unlawful killing | 1996 | False | 1996.199951 | 85-89 | Women |
| 154 | 1996 | September | 20 | 1996-09-20 | Anne Lilian Ralphs | 75 | Own home | Unlawful killing | 1996 | False | 1996.219971 | 75-79 | Women |
| 155 | 1996 | October | 23 | 1996-10-23 | Millicent Garside | 76 | Own home | Unlawful killing | 1996 | False | 1996.310059 | 75-79 | Women |
| 156 | 1996 | November | 20 | 1996-11-20 | Irene Heathcote | 76 | Own home | Unlawful killing | 1996 | False | 1996.390015 | 75-79 | Women |
| 157 | 1996 | November | 23 | 1996-11-23 | Samuel Mills | 89 | Own home | Unlawful killing | 1996 | False | 1996.400024 | 85-89 | Women |
| 158 | 1996 | December | 4 | 1996-12-04 | Thomas Cheetham | 78 | Own home | Unlawful killing | 1996 | True | 1996.430054 | 75-79 | Men |
| 159 | 1996 | December | 17 | 1996-12-17 | Kenneth Ernest Smith | 73 | Own home | Unlawful killing | 1996 | True | 1996.459961 | 70-74 | Men |
| 160 | 1997 | January | 2 | 1997-01-02 | Eileen Daphne Crompton | 75 | Residential home | Unlawful killing | 1997 | False | 1996.510010 | 75-79 | Women |
| 161 | 1997 | January | 3 | 1997-01-03 | David Alan Harrison | 47 | Own home | Unlawful killing | 1997 | True | 1996.510010 | 45-49 | Men |
| 162 | 1997 | January | 8 | 1997-01-08 | Elsie Lorna Dean | 69 | Own home | Unlawful killing | 1997 | False | 1996.520020 | 65-69 | Women |
| 163 | 1997 | January | 20 | 1997-01-20 | Irene Brooder | 76 | Own home | Unlawful killing | 1997 | False | 1996.560059 | 75-79 | Women |
| 164 | 1997 | January | 27 | 1997-01-27 | Charlotte Bennison | 89 | Own home | Unlawful killing | 1997 | False | 1996.579956 | 85-89 | Women |
| 165 | 1997 | February | 3 | 1997-02-03 | Charles Henry Killan | 90 | Own home | Unlawful killing | 1997 | False | 1996.589966 | 90-94 | Women |
| 166 | 1997 | February | 4 | 1997-02-04 | Betty Royston | 70 | Own home | Unlawful killing | 1997 | False | 1996.599976 | 70-74 | Women |
| 167 | 1997 | February | 23 | 1997-02-23 | Joyce Woodhead | 74 | Own home | Unlawful killing | 1997 | False | 1996.650024 | 70-74 | Women |
| 168 | 1997 | February | 28 | 1997-02-28 | Lizzie Adams | 77 | Own home | Conviction | 1997 | False | 1996.660034 | 75-79 | Women |
| 169 | 1997 | March | 22 | 1997-03-22 | Rose Garlick | 76 | Own home | Unlawful killing | 1997 | False | 1996.719971 | 75-79 | Women |
| 170 | 1997 | March | 27 | 1997-03-27 | May Lowe | 84 | Own home | Unlawful killing | 1997 | False | 1996.739990 | 80-84 | Women |
| 171 | 1997 | April | 21 | 1997-04-21 | Mary Coutts | 80 | Own home | Unlawful killing | 1997 | False | 1996.810059 | 80-84 | Women |
| 172 | 1997 | April | 25 | 1997-04-25 | Elsie Cheetham | 76 | Own home | Unlawful killing | 1997 | False | 1996.819946 | 75-79 | Women |
| 173 | 1997 | April | 25 | 1997-04-25 | Jean Lilley | 58 | Own home | Conviction | 1997 | False | 1996.819946 | 55-59 | Women |
| 174 | 1997 | May | 2 | 1997-05-02 | Lena Norah Slater | 68 | Own home | Unlawful killing | 1997 | False | 1996.839966 | 65-69 | Women |
| 175 | 1997 | May | 12 | 1997-05-12 | Ethel May Kellett | 74 | Own home | Unlawful killing | 1997 | False | 1996.859985 | 70-74 | Women |
| 176 | 1997 | May | 21 | 1997-05-21 | Doris Earls | 79 | Own home | Unlawful killing | 1997 | False | 1996.890015 | 75-79 | Women |
| 177 | 1997 | May | 29 | 1997-05-29 | Ivy Lomas | 63 | Shipman's surgery | Conviction | 1997 | False | 1996.910034 | 60-64 | Women |
| 178 | 1997 | June | 24 | 1997-06-24 | Vera Whittingslow | 69 | Own home | Unlawful killing | 1997 | False | 1996.979980 | 65-69 | Women |
| 179 | 1997 | July | 7 | 1997-07-07 | Maureen Lamonnier Jackson | 51 | Own home | Unlawful killing | 1997 | False | 1997.020020 | 50-54 | Women |
| 180 | 1997 | July | 14 | 1997-07-14 | Muriel Grimshaw | 76 | Own home | Conviction | 1997 | False | 1997.040039 | 75-79 | Women |
| 181 | 1997 | July | 25 | 1997-07-25 | John Louden Livesey | 69 | Own home | Unlawful killing | 1997 | True | 1997.069946 | 65-69 | Men |
| 182 | 1997 | July | 28 | 1997-07-28 | Lily Newby Taylor | 86 | Own home | Unlawful killing | 1997 | False | 1997.069946 | 85-89 | Women |
| 183 | 1997 | August | 10 | 1997-08-10 | Dorothy Doretta Hopkins | 72 | Own home | Unlawful killing | 1997 | False | 1997.109985 | 70-74 | Women |
| 184 | 1997 | September | 1 | 1997-09-01 | Nancy Jackson | 81 | Own home | Unlawful killing | 1997 | False | 1997.170044 | 80-84 | Women |
| 185 | 1997 | September | 22 | 1997-09-22 | Mavis Mary Pickup | 79 | Own home | Unlawful killing | 1997 | False | 1997.229980 | 75-79 | Women |
| 186 | 1997 | September | 26 | 1997-09-26 | Bessie Swann | 79 | Own home | Unlawful killing | 1997 | False | 1997.239990 | 75-79 | Women |
| 187 | 1997 | September | 29 | 1997-09-29 | Enid Otter | 77 | Own home | Unlawful killing | 1997 | False | 1997.250000 | 75-79 | Women |
| 188 | 1997 | November | 10 | 1997-11-10 | Florence Lewis | 79 | Own home | Unlawful killing | 1997 | False | 1997.359985 | 75-79 | Women |
| 189 | 1997 | November | 14 | 1997-11-14 | Mary Walls | 78 | Own home | Unlawful killing | 1997 | False | 1997.369995 | 75-79 | Women |
| 190 | 1997 | November | 21 | 1997-11-21 | Elizabeth Mary Baddeley | 83 | Own home | Unlawful killing | 1997 | False | 1997.390015 | 80-84 | Women |
| 191 | 1997 | November | 24 | 1997-11-24 | Marie Quinn | 67 | Own home | Conviction | 1997 | False | 1997.400024 | 65-69 | Women |
| 192 | 1997 | December | 8 | 1997-12-08 | Elizabeth Battersby | 70 | Own home | Unlawful killing | 1997 | False | 1997.439941 | 70-74 | Women |
| 193 | 1997 | December | 9 | 1997-12-09 | Laura Kathleen Wagstaff | 81 | Own home | Conviction | 1997 | False | 1997.439941 | 80-84 | Women |
| 194 | 1997 | December | 10 | 1997-12-10 | Bianka Pomfret | 49 | Own home | Conviction | 1997 | False | 1997.439941 | 45-49 | Women |
| 195 | 1997 | December | 18 | 1997-12-18 | Alice Black | 73 | Own home | Unlawful killing | 1997 | False | 1997.469971 | 70-74 | Women |
| 196 | 1997 | December | 24 | 1997-12-24 | James Joseph King | 83 | Own home | Unlawful killing | 1997 | True | 1997.479980 | 80-84 | Men |
| 197 | 1998 | January | 22 | 1998-01-22 | Mabel Shawcross | 79 | Own home | Unlawful killing | 1998 | False | 1997.560059 | 75-79 | Women |
| 198 | 1998 | January | 26 | 1998-01-26 | Norah Nuttall | 64 | Own home | Conviction | 1998 | False | 1997.569946 | 60-64 | Women |
| 199 | 1998 | February | 2 | 1998-02-02 | Cissie Davies | 73 | Own home | Unlawful killing | 1998 | False | 1997.589966 | 70-74 | Women |
| 200 | 1998 | February | 9 | 1998-02-09 | Pamela Marguerite Hillier | 68 | Own home | Conviction | 1998 | False | 1997.609985 | 65-69 | Women |
| 201 | 1998 | February | 13 | 1998-02-13 | Laura Frances Linn | 83 | Own home | Unlawful killing | 1998 | False | 1997.619995 | 80-84 | Women |
| 202 | 1998 | February | 15 | 1998-02-15 | Irene Berry | 74 | Own home | Unlawful killing | 1998 | False | 1997.630005 | 70-74 | Women |
| 203 | 1998 | February | 18 | 1998-02-18 | Maureen Alice Ward | 57 | Own home | Conviction | 1998 | False | 1997.640015 | 55-59 | Women |
| 204 | 1998 | February | 27 | 1998-02-27 | Joan Edwina Dean | 75 | Own home | Unlawful killing | 1998 | False | 1997.660034 | 75-79 | Women |
| 205 | 1998 | March | 4 | 1998-03-04 | Harold Eddleston | 77 | Own home | Unlawful killing | 1998 | True | 1997.670044 | 75-79 | Men |
| 206 | 1998 | March | 6 | 1998-03-06 | Margaret Anne Waldron | 65 | Own home | Unlawful killing | 1998 | False | 1997.680054 | 65-69 | Women |
| 207 | 1998 | March | 7 | 1998-03-07 | Irene Chapman | 74 | Own home | Unlawful killing | 1998 | False | 1997.680054 | 70-74 | Women |
| 208 | 1998 | March | 13 | 1998-03-13 | Dorothy Long | 84 | Own home | Unlawful killing | 1998 | False | 1997.699951 | 80-84 | Women |
| 209 | 1998 | March | 17 | 1998-03-17 | Lily Higgins | 83 | Own home | Unlawful killing | 1998 | False | 1997.709961 | 80-84 | Women |
| 210 | 1998 | March | 20 | 1998-03-20 | Ada Warburton | 77 | Own home | Unlawful killing | 1998 | False | 1997.719971 | 75-79 | Women |
| 211 | 1998 | March | 24 | 1998-03-24 | Martha Marley | 88 | Own home | Unlawful killing | 1998 | False | 1997.729980 | 85-89 | Women |
| 212 | 1998 | May | 11 | 1998-05-11 | Winifred Mellor | 73 | Own home | Conviction | 1998 | False | 1997.859985 | 70-74 | Women |
| 213 | 1998 | June | 12 | 1998-06-12 | Joan May Melia | 73 | Own home | Conviction | 1998 | False | 1997.949951 | 70-74 | Women |
| 214 | 1998 | June | 24 | 1998-06-24 | Kathleen Grundy | 81 | Own home | Conviction | 1998 | False | 1997.979980 | 80-84 | Women |
Shipman killed most of his victims diring fall time, especially December.
month=df["Month"]
year = df["Year"]
fig = px.box(x=month, y=year)
fig.update_layout(title=dict(text="Shipman's killings per months in a spam or more than 3 decades"), font=dict(size=15))
fig.update_layout(paper_bgcolor="lightpink", plot_bgcolor="rgba(0,0,0,0)")
fig.update_layout(
xaxis_title="Months",
yaxis_title="Years ",
legend_title="Legend Title"
)
fig.show()
End of the Analysis
cursor = conn.cursor()
cursor.close()
print("Connection has been closed!!")
Connection has been closed!!